Overview

Dataset info

Number of variables46
Number of observations16947
Missing cells11177 (1.4%)
Duplicate rows0 (0.0%)
Total size in memory5.9 MiB
Average record size in memory368.0 B

Variables types

Numeric8
Categorical28
Boolean4
Date6
URL0
Text (Unique)0
Rejected0
Unsupported0

Warnings

Account_Name has a high cardinality: 1635 distinct values Warning
ASP has 301 (1.8%) zeros Zeros
ASP has 3209 (18.9%) missing values Missing
ASP_(converted) is highly skewed (γ1 = 80.47407411) Skewed
ASP_(converted) has 300 (1.8%) zeros Zeros
ASP_(converted) has 3209 (18.9%) missing values Missing
Billing_Country has a high cardinality: 80 distinct values Warning
Last_Modified_By has a high cardinality: 55 distinct values Warning
Month has a high cardinality: 53 distinct values Warning
Opportunity_Name has a high cardinality: 9841 distinct values Warning
Opportunity_Owner has a high cardinality: 53 distinct values Warning
Price has a high cardinality: 53 distinct values Warning
Product_Family has a high cardinality: 227 distinct values Warning
Product_Name has a high cardinality: 456 distinct values Warning
Quote_Expiry_Date has 4625 (27.3%) missing values Missing
Sales_Contract_No has a high cardinality: 5267 distinct values Warning
Territory has a high cardinality: 76 distinct values Warning
Total_Amount is highly skewed (γ1 = 42.00442155) Skewed
Total_Taxable_Amount is highly skewed (γ1 = 33.59918963) Skewed
Total_Taxable_Amount has 997 (5.9%) zeros Zeros
TRF has 11971 (70.6%) zeros Zeros

Variables

Account_Created_Date
Date

Distinct count809
Unique (%)4.8%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Minimum2013-07-27 00:00:00
Maximum2018-12-21 00:00:00
Mini histogram
Histogram
Histogram of 'Account_Created_Date' (bins=N)

Account_Name
Categorical

Distinct count1635
Unique (%)9.6%
Missing (%)0.0%
Missing (n)0
Account_Name_1888
 
2124
Account_Name_1836
 
886
Account_Name_25
 
752
Other values (1632)
13185
ValueCountFrequency (%) 
Account_Name_1888 2124 12.5%
 
Account_Name_1836 886 5.2%
 
Account_Name_25 752 4.4%
 
Account_Name_1991 586 3.5%
 
Account_Name_1642 397 2.3%
 
Account_Name_1508 355 2.1%
 
Account_Name_1440 317 1.9%
 
Account_Name_533 283 1.7%
 
Account_Name_263 249 1.5%
 
Account_Name_660 231 1.4%
 
Other values (1625) 10767 63.5%
 
Max length17
Mean length16.51560748
Min length14
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Account_Owner
Categorical

Distinct count48
Unique (%)0.3%
Missing (%)0.0%
Missing (n)0
Person_Name_50
3730
Person_Name_13
 
1328
Person_Name_8
 
1286
Other values (45)
10603
ValueCountFrequency (%) 
Person_Name_50 3730 22.0%
 
Person_Name_13 1328 7.8%
 
Person_Name_8 1286 7.6%
 
Person_Name_43 1241 7.3%
 
Person_Name_18 1093 6.4%
 
Person_Name_3 875 5.2%
 
Person_Name_32 682 4.0%
 
Person_Name_4 664 3.9%
 
Person_Name_65 631 3.7%
 
Person_Name_64 577 3.4%
 
Other values (38) 4840 28.6%
 
Max length14
Mean length13.80090872
Min length13
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Account_Type
Categorical

Distinct count7
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Account_Type_2
8832
Account_Type_0
5868
Account_Type_5
1943
Other values (4)
 
304
ValueCountFrequency (%) 
Account_Type_2 8832 52.1%
 
Account_Type_0 5868 34.6%
 
Account_Type_5 1943 11.5%
 
Account_Type_1 165 1.0%
 
None 112 0.7%
 
Account_Type_6 17 0.1%
 
Account_Type_4 10 0.1%
 
Max length14
Mean length13.93391161
Min length4
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

ASP
Numeric

Distinct count302
Unique (%)1.8%
Missing (%)18.9%
Missing (n)3209
Infinite (%)0.0%
Infinite (n)0
Mean7.012128279
Minimum0
Maximum80
Zeros (%)1.8%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0.25
Q10.36
Median0.4
Q30.505
95-th percentile59
Maximum80
Range80
Interquartile range0.145

Descriptive statistics

Standard deviation18.85835901
Coef of variation2.689391617
Kurtosis5.261237009
Mean7.012128279
MAD11.7241345
Skewness2.623799882
Sum96332.6183
Variance355.6377046
Memory size132.5 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0.38 801 4.7%
 
0.4 712 4.2%
 
0.36 564 3.3%
 
0.42 510 3.0%
 
0.39 465 2.7%
 
0.37 365 2.2%
 
0 301 1.8%
 
0.35 295 1.7%
 
0.34 270 1.6%
 
0.365 269 1.6%
 
Other values (291) 9186 54.2%
 
(Missing) 3209 18.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 301 1.8%
 
1e-05 1 < 0.1%
 
0.15 53 0.3%
 
0.16 8 < 0.1%
 
0.17 114 0.7%
 

Maximum 5 values

ValueCountFrequency (%) 
80 14 0.1%
 
78 86 0.5%
 
77 12 0.1%
 
76 6 < 0.1%
 
75 99 0.6%
 

ASP_(converted)
Numeric

Distinct count442
Unique (%)2.6%
Missing (%)18.9%
Missing (n)3209
Infinite (%)0.0%
Infinite (n)0
Mean0.4325537043
Minimum0
Maximum67
Zeros (%)1.8%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0.27
Q10.37326
Median0.41285
Q30.47649
95-th percentile0.63
Maximum67
Range67
Interquartile range0.10323

Descriptive statistics

Standard deviation0.7586587831
Coef of variation1.753906568
Kurtosis6675.953735
Mean0.4325537043
MAD0.09218016785
Skewness80.47407411
Sum5942.42279
Variance0.5755631491
Memory size132.5 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0.38 570 3.4%
 
0.4 497 2.9%
 
0.36 326 1.9%
 
0.39 325 1.9%
 
0 300 1.8%
 
0.42 294 1.7%
 
0.40719 234 1.4%
 
0.42982 230 1.4%
 
0.47506 216 1.3%
 
0.45244 214 1.3%
 
Other values (431) 10532 62.1%
 
(Missing) 3209 18.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 300 1.8%
 
1e-05 1 < 0.1%
 
0.00378 1 < 0.1%
 
0.15 53 0.3%
 
0.16 8 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
67 1 < 0.1%
 
57.68578 1 < 0.1%
 
1.7 1 < 0.1%
 
1.6 6 < 0.1%
 
1 2 < 0.1%
 

ASP_Currency
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
USD
7361
JPY
4522
EUR
4503
Other values (2)
 
561
ValueCountFrequency (%) 
USD 7361 43.4%
 
JPY 4522 26.7%
 
EUR 4503 26.6%
 
AUD 556 3.3%
 
GBP 5 < 0.1%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

Billing_Country
Categorical

Distinct count80
Unique (%)0.5%
Missing (%)0.0%
Missing (n)0
Japan
4879
United States
3802
Germany
1979
Other values (77)
6287
ValueCountFrequency (%) 
Japan 4879 28.8%
 
United States 3802 22.4%
 
Germany 1979 11.7%
 
Australia 1169 6.9%
 
India 672 4.0%
 
Netherlands 563 3.3%
 
Singapore 432 2.5%
 
France 396 2.3%
 
Spain 317 1.9%
 
Italy 295 1.7%
 
Other values (70) 2443 14.4%
 
Max length42
Mean length8.187289786
Min length4
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

Brand
Categorical

Distinct count26
Unique (%)0.2%
Missing (%)0.0%
Missing (n)0
None
15911
Other
 
607
Brand_9
 
140
Other values (23)
 
289
ValueCountFrequency (%) 
None 15911 93.9%
 
Other 607 3.6%
 
Brand_9 140 0.8%
 
Brand_5 48 0.3%
 
Brand_24 38 0.2%
 
Brand_11 34 0.2%
 
Brand_25 24 0.1%
 
Brand_10 22 0.1%
 
Brand_22 20 0.1%
 
Brand_21 17 0.1%
 
Other values (16) 86 0.5%
 
Max length8
Mean length4.12409276
Min length4
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Bureaucratic_Code
Categorical

Distinct count7
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Bureaucratic_Code_4
12587
Bureaucratic_Code_5
3803
Bureaucratic_Code_1
 
261
Other values (4)
 
296
ValueCountFrequency (%) 
Bureaucratic_Code_4 12587 74.3%
 
Bureaucratic_Code_5 3803 22.4%
 
Bureaucratic_Code_1 261 1.5%
 
Bureaucratic_Code_2 242 1.4%
 
Bureaucratic_Code_0 51 0.3%
 
Bureaucratic_Code_3 2 < 0.1%
 
Bureaucratic_Code_6 1 < 0.1%
 
Max length19
Mean length19
Min length19
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Bureaucratic_Code_0_Approval
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
8889
1
8058
ValueCountFrequency (%) 
0 8889 52.5%
 
1 8058 47.5%
 

Bureaucratic_Code_0_Approved
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
11543
1
5404
ValueCountFrequency (%) 
0 11543 68.1%
 
1 5404 31.9%
 

Currency
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
None
16052
EUR
 
475
USD
 
420
ValueCountFrequency (%) 
None 16052 94.7%
 
EUR 475 2.8%
 
USD 420 2.5%
 
Max length4
Mean length3.947188293
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

Delivery_Quarter
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Q2
4443
Q1
4317
Q4
4144
ValueCountFrequency (%) 
Q2 4443 26.2%
 
Q1 4317 25.5%
 
Q4 4144 24.5%
 
Q3 4043 23.9%
 
Max length2
Mean length2
Min length2
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Delivery_Terms
Categorical

Distinct count9
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
Delivery_Terms_4
7712
Delivery_Terms_2
4633
Delivery_Terms_1
2936
Other values (6)
1666
ValueCountFrequency (%) 
Delivery_Terms_4 7712 45.5%
 
Delivery_Terms_2 4633 27.3%
 
Delivery_Terms_1 2936 17.3%
 
Delivery_Terms_6 781 4.6%
 
Delivery_Terms_5 636 3.8%
 
Delivery_Terms_8 164 1.0%
 
Delivery_Terms_3 41 0.2%
 
Delivery_Terms_7 38 0.2%
 
Delivery_Terms_0 6 < 0.1%
 
Max length16
Mean length16
Min length16
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Delivery_Year
Numeric

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean2017.137428
Minimum2016
Maximum2020
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2016
5-th percentile2016
Q12016
Median2017
Q32018
95-th percentile2018
Maximum2020
Range4
Interquartile range2

Descriptive statistics

Standard deviation0.8296028156
Coef of variation0.0004112772902
Kurtosis-0.9481673267
Mean2017.137428
MAD0.6892043121
Skewness0.03065373257
Sum34184428
Variance0.6882408316
Memory size132.5 KiB
Histogram
Histogram with fixed size bins (bins=5)
ValueCountFrequency (%) 
2017 6318 37.3%
 
2018 5830 34.4%
 
2016 4371 25.8%
 
2019 414 2.4%
 
2020 14 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
2016 4371 25.8%
 
2017 6318 37.3%
 
2018 5830 34.4%
 
2019 414 2.4%
 
2020 14 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
2020 14 0.1%
 
2019 414 2.4%
 
2018 5830 34.4%
 
2017 6318 37.3%
 
2016 4371 25.8%
 

ID
Numeric

Distinct count16947
Unique (%)100.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean17666.65044
Minimum4854
Maximum28773
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum4854
5-th percentile6095.3
Q111953
Median18114
Q323845.5
95-th percentile27687.4
Maximum28773
Range23919
Interquartile range11892.5

Descriptive statistics

Standard deviation6940.859372
Coef of variation0.3928791933
Kurtosis-1.172033787
Mean17666.65044
MAD5997.31525
Skewness-0.1785736993
Sum299396725
Variance48175528.83
Memory size132.5 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 4854. 5791. 12402. 16051.5 16533.5 19385.5 20799.5 23849.5 23897.5 28773. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
6141 1 < 0.1%
 
27384 1 < 0.1%
 
21263 1 < 0.1%
 
19212 1 < 0.1%
 
25353 1 < 0.1%
 
27400 1 < 0.1%
 
4871 1 < 0.1%
 
13059 1 < 0.1%
 
15106 1 < 0.1%
 
8961 1 < 0.1%
 
Other values (16937) 16937 99.9%
 

Minimum 5 values

ValueCountFrequency (%) 
4854 1 < 0.1%
 
4856 1 < 0.1%
 
4858 1 < 0.1%
 
4859 1 < 0.1%
 
4860 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
28773 1 < 0.1%
 
28772 1 < 0.1%
 
28771 1 < 0.1%
 
28770 1 < 0.1%
 
28769 1 < 0.1%
 

Last_Modified_By
Categorical

Distinct count55
Unique (%)0.3%
Missing (%)0.0%
Missing (n)0
Person_Name_47
8515
Person_Name_50
 
1210
Person_Name_43
 
587
Other values (52)
6635
ValueCountFrequency (%) 
Person_Name_47 8515 50.2%
 
Person_Name_50 1210 7.1%
 
Person_Name_43 587 3.5%
 
Person_Name_13 578 3.4%
 
Person_Name_8 511 3.0%
 
Person_Name_18 438 2.6%
 
Person_Name_33 429 2.5%
 
Person_Name_19 395 2.3%
 
Person_Name_3 395 2.3%
 
Person_Name_4 315 1.9%
 
Other values (45) 3574 21.1%
 
Max length14
Mean length13.89809406
Min length13
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Last_Modified_Date
Date

Distinct count650
Unique (%)3.8%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Minimum2015-03-12 00:00:00
Maximum2018-12-29 00:00:00
Mini histogram
Histogram
Histogram of 'Last_Modified_Date' (bins=N)

Month
Categorical

Distinct count53
Unique (%)0.3%
Missing (%)0.0%
Missing (n)0
2018 - 10
 
666
2017 - 6
 
643
2017 - 10
 
638
Other values (50)
15000
ValueCountFrequency (%) 
2018 - 10 666 3.9%
 
2017 - 6 643 3.8%
 
2017 - 10 638 3.8%
 
2016 - 3 628 3.7%
 
2017 - 7 625 3.7%
 
2017 - 5 586 3.5%
 
2018 - 4 579 3.4%
 
2017 - 12 574 3.4%
 
2018 - 6 542 3.2%
 
2018 - 7 536 3.2%
 
Other values (43) 10930 64.5%
 
Max length9
Mean length8.244527055
Min length8
Contains charsFalse
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

Opportunity_Created_Date
Date

Distinct count1096
Unique (%)6.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Minimum2013-11-05 00:00:00
Maximum2018-12-29 00:00:00
Mini histogram
Histogram
Histogram of 'Opportunity_Created_Date' (bins=N)

Opportunity_ID
Numeric

Distinct count9841
Unique (%)58.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean5335.940225
Minimum0
Maximum12803
Zeros (%)< 0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile435.3
Q12448.5
Median5306
Q37698
95-th percentile11203.5
Maximum12803
Range12803
Interquartile range5249.5

Descriptive statistics

Standard deviation3324.723809
Coef of variation0.623081157
Kurtosis-0.7150386945
Mean5335.940225
MAD2797.70729
Skewness0.2852975553
Sum90428179
Variance11053788.41
Memory size132.5 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.00000e+00 7.50000e+00 1.85000e+01 3.55000e+01 4.45000e+01 ... 1.27095e+04 1.27225e+04 1.27725e+04 1.27815e+04 1.28030e+04], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
12460 36 0.2%
 
2008 36 0.2%
 
5123 26 0.2%
 
6606 26 0.2%
 
2911 24 0.1%
 
767 18 0.1%
 
6654 16 0.1%
 
8698 16 0.1%
 
6653 16 0.1%
 
7568 16 0.1%
 
Other values (9831) 16717 98.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1 < 0.1%
 
1 1 < 0.1%
 
2 1 < 0.1%
 
3 1 < 0.1%
 
4 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
12803 1 < 0.1%
 
12802 1 < 0.1%
 
12801 3 < 0.1%
 
12800 2 < 0.1%
 
12799 1 < 0.1%
 

Opportunity_Name
Categorical

Distinct count9841
Unique (%)58.1%
Missing (%)0.0%
Missing (n)0
Opportunity_Name_5036
 
36
Opportunity_Name_9795
 
36
Opportunity_Name_12179
 
26
Other values (9838)
16849
ValueCountFrequency (%) 
Opportunity_Name_5036 36 0.2%
 
Opportunity_Name_9795 36 0.2%
 
Opportunity_Name_12179 26 0.2%
 
Opportunity_Name_11461 26 0.2%
 
Opportunity_Name_6835 24 0.1%
 
Opportunity_Name_1661 18 0.1%
 
Opportunity_Name_9628 16 0.1%
 
Opportunity_Name_10131 16 0.1%
 
Opportunity_Name_10944 16 0.1%
 
Opportunity_Name_10945 16 0.1%
 
Other values (9831) 16717 98.6%
 
Max length22
Mean length21.15271139
Min length18
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Opportunity_Owner
Categorical

Distinct count53
Unique (%)0.3%
Missing (%)0.0%
Missing (n)0
Person_Name_50
3781
Person_Name_8
 
1422
Person_Name_13
 
1254
Other values (50)
10490
ValueCountFrequency (%) 
Person_Name_50 3781 22.3%
 
Person_Name_8 1422 8.4%
 
Person_Name_13 1254 7.4%
 
Person_Name_18 982 5.8%
 
Person_Name_43 838 4.9%
 
Person_Name_3 832 4.9%
 
Person_Name_4 687 4.1%
 
Person_Name_32 686 4.0%
 
Person_Name_19 615 3.6%
 
Person_Name_64 516 3.0%
 
Other values (43) 5334 31.5%
 
Max length14
Mean length13.8094648
Min length13
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Opportunity_Type
Categorical

Distinct count25
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
Opportunity_Type_1
6819
Opportunity_Type_7
5763
Opportunity_Type_19
1900
Other values (22)
2465
ValueCountFrequency (%) 
Opportunity_Type_1 6819 40.2%
 
Opportunity_Type_7 5763 34.0%
 
Opportunity_Type_19 1900 11.2%
 
Opportunity_Type_8 1458 8.6%
 
Opportunity_Type_12 279 1.6%
 
Opportunity_Type_3 275 1.6%
 
Opportunity_Type_20 175 1.0%
 
Opportunity_Type_2 70 0.4%
 
Opportunity_Type_4 51 0.3%
 
Opportunity_Type_10 34 0.2%
 
Other values (15) 123 0.7%
 
Max length19
Mean length18.14539447
Min length18
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Planned_Delivery_End_Date
Date

Distinct count1017
Unique (%)6.0%
Missing (%)0.4%
Missing (n)75
Infinite (%)0.0%
Infinite (n)0
Minimum2016-01-05 00:00:00
Maximum2208-12-31 00:00:00
Mini histogram
Histogram
Histogram of 'Planned_Delivery_End_Date' (bins=N)

Planned_Delivery_Start_Date
Date

Distinct count986
Unique (%)5.8%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Minimum2016-01-01 00:00:00
Maximum2020-09-17 00:00:00
Mini histogram
Histogram
Histogram of 'Planned_Delivery_Start_Date' (bins=N)

Price
Categorical

Distinct count53
Unique (%)0.3%
Missing (%)0.0%
Missing (n)0
None
15982
Other
 
609
0.24
 
27
Other values (50)
 
329
ValueCountFrequency (%) 
None 15982 94.3%
 
Other 609 3.6%
 
0.24 27 0.2%
 
0.41 22 0.1%
 
0.28 20 0.1%
 
0.27 18 0.1%
 
0.29 17 0.1%
 
0.32 15 0.1%
 
0.38 14 0.1%
 
0.35 14 0.1%
 
Other values (43) 209 1.2%
 
Max length5
Mean length4.039062961
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

Pricing,_Delivery_Terms_Approved
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
1
9890
0
7057
ValueCountFrequency (%) 
1 9890 58.4%
 
0 7057 41.6%
 

Pricing,_Delivery_Terms_Quote_Appr
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
1
13693
0
3254
ValueCountFrequency (%) 
1 13693 80.8%
 
0 3254 19.2%
 

Product_Category_B
Categorical

Distinct count28
Unique (%)0.2%
Missing (%)0.0%
Missing (n)0
None
15928
Other
 
523
Product_Category_B_2
 
59
Other values (25)
 
437
ValueCountFrequency (%) 
None 15928 94.0%
 
Other 523 3.1%
 
Product_Category_B_2 59 0.3%
 
Product_Category_B_12 51 0.3%
 
Product_Category_B_7 47 0.3%
 
Product_Category_B_4 37 0.2%
 
Product_Category_B_5 36 0.2%
 
Product_Category_B_17 27 0.2%
 
Product_Category_B_1 24 0.1%
 
Product_Category_B_8 23 0.1%
 
Other values (18) 192 1.1%
 
Max length21
Mean length4.512008025
Min length4
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Product_Family
Categorical

Distinct count227
Unique (%)1.3%
Missing (%)0.0%
Missing (n)0
Product_Family_77
 
1345
Product_Family_133
 
1249
Product_Family_132
 
763
Other values (224)
13590
ValueCountFrequency (%) 
Product_Family_77 1345 7.9%
 
Product_Family_133 1249 7.4%
 
Product_Family_132 763 4.5%
 
Product_Family_212 636 3.8%
 
Product_Family_100 619 3.7%
 
Product_Family_85 596 3.5%
 
Product_Family_115 540 3.2%
 
Product_Family_226 524 3.1%
 
Product_Family_109 499 2.9%
 
Product_Family_208 478 2.8%
 
Other values (217) 9698 57.2%
 
Max length18
Mean length17.6441258
Min length16
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Product_Name
Categorical

Distinct count456
Unique (%)2.7%
Missing (%)0.0%
Missing (n)0
Product_Name_100
 
976
Product_Name_226
 
836
Product_Name_231
 
579
Other values (453)
14556
ValueCountFrequency (%) 
Product_Name_100 976 5.8%
 
Product_Name_226 836 4.9%
 
Product_Name_231 579 3.4%
 
Product_Name_491 524 3.1%
 
Product_Name_4 474 2.8%
 
Product_Name_192 442 2.6%
 
Product_Name_111 388 2.3%
 
Product_Name_132 383 2.3%
 
Product_Name_495 350 2.1%
 
Product_Name_29 345 2.0%
 
Other values (446) 11650 68.7%
 
Max length16
Mean length15.74609075
Min length14
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Product_Type
Categorical

Distinct count7
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
None
15935
Other
 
515
Product_Type_3
 
179
Other values (4)
 
318
ValueCountFrequency (%) 
None 15935 94.0%
 
Other 515 3.0%
 
Product_Type_3 179 1.1%
 
Product_Type_1 142 0.8%
 
Product_Type_0 94 0.6%
 
Product_Type_4 73 0.4%
 
Product_Type_2 9 0.1%
 
Max length14
Mean length4.323656104
Min length4
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Quote_Expiry_Date
Date

Distinct count1003
Unique (%)5.9%
Missing (%)27.3%
Missing (n)4625
Infinite (%)0.0%
Infinite (n)0
Minimum2014-09-30 00:00:00
Maximum2019-06-30 00:00:00
Mini histogram
Histogram
Histogram of 'Quote_Expiry_Date' (bins=N)

Quote_Type
Categorical

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Non Binding
16777
Binding
 
170
ValueCountFrequency (%) 
Non Binding 16777 99.0%
 
Binding 170 1.0%
 
Max length11
Mean length10.9598749
Min length7
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

Region
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Japan
4892
EMEA
4664
Americas
3945
Other values (2)
3446
ValueCountFrequency (%) 
Japan 4892 28.9%
 
EMEA 4664 27.5%
 
Americas 3945 23.3%
 
APAC 3262 19.2%
 
Middle East 184 1.1%
 
Max length11
Mean length5.295804567
Min length4
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

Sales_Contract_No
Categorical

Distinct count5267
Unique (%)31.1%
Missing (%)0.0%
Missing (n)0
None
6973
479
 
36
108
 
36
Other values (5264)
9902
ValueCountFrequency (%) 
None 6973 41.1%
 
479 36 0.2%
 
108 36 0.2%
 
2575 18 0.1%
 
3878 16 0.1%
 
3877 16 0.1%
 
3980 16 0.1%
 
5583 16 0.1%
 
3876 16 0.1%
 
3123 16 0.1%
 
Other values (5257) 9788 57.8%
 
Max length4
Mean length3.875376173
Min length1
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Size
Categorical

Distinct count7
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
None
15967
Other
 
394
Size_3
 
356
Other values (4)
 
230
ValueCountFrequency (%) 
None 15967 94.2%
 
Other 394 2.3%
 
Size_3 356 2.1%
 
Size_4 196 1.2%
 
Size_1 25 0.1%
 
Size_0 7 < 0.1%
 
Size_2 2 < 0.1%
 
Max length6
Mean length4.092405736
Min length4
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Source_
Categorical

Distinct count14
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
None
9497
Source_7
2965
Source_9
 
1459
Other values (11)
3026
ValueCountFrequency (%) 
None 9497 56.0%
 
Source_7 2965 17.5%
 
Source_9 1459 8.6%
 
Source_11 1421 8.4%
 
Source_13 786 4.6%
 
Source_3 418 2.5%
 
Source_1 137 0.8%
 
Source_10 106 0.6%
 
Source_2 86 0.5%
 
Source_4 43 0.3%
 
Other values (4) 29 0.2%
 
Max length9
Mean length5.895025668
Min length4
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Stage
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Closed Won
9533
Closed Lost
7350
Proposal
 
35
Other values (2)
 
29
ValueCountFrequency (%) 
Closed Won 9533 56.3%
 
Closed Lost 7350 43.4%
 
Proposal 35 0.2%
 
Negotiation 18 0.1%
 
Qualification 11 0.1%
 
Max length13
Mean length10.43258394
Min length8
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

Territory
Categorical

Distinct count76
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
None
4999
Germany
 
1682
NW America
 
1568
Other values (73)
8698
ValueCountFrequency (%) 
None 4999 29.5%
 
Germany 1682 9.9%
 
NW America 1568 9.3%
 
Australia 1208 7.1%
 
India 809 4.8%
 
NE America 760 4.5%
 
Japan 681 4.0%
 
Netherlands 533 3.1%
 
SE America 493 2.9%
 
France 449 2.6%
 
Other values (66) 3765 22.2%
 
Max length20
Mean length7.018646368
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

Total_Amount
Numeric

Distinct count8873
Unique (%)52.4%
Missing (%)0.3%
Missing (n)59
Infinite (%)0.0%
Infinite (n)0
Mean1993659.215
Minimum0
Maximum1320000000
Zeros (%)0.3%
Mini histogram

Quantile statistics

Minimum0
5-th percentile2900
Q126775
Median107250
Q3460389.825
95-th percentile7010372.365
Maximum1320000000
Range1320000000
Interquartile range433614.825

Descriptive statistics

Standard deviation18484259.88
Coef of variation9.271524312
Kurtosis2322.422807
Mean1993659.215
MAD3088832.222
Skewness42.00442155
Sum3.366891683e+10
Variance3.416678634e+14
Memory size132.5 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
6200 513 3.0%
 
4400 461 2.7%
 
18000 353 2.1%
 
140000 272 1.6%
 
1600 204 1.2%
 
160000 132 0.8%
 
109620 100 0.6%
 
23400 80 0.5%
 
85260 75 0.4%
 
81200 75 0.4%
 
Other values (8862) 14623 86.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 52 0.3%
 
0.01 7 < 0.1%
 
0.02 3 < 0.1%
 
0.04 1 < 0.1%
 
0.1 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1320000000 1 < 0.1%
 
919992410 1 < 0.1%
 
760000000 1 < 0.1%
 
660005280 1 < 0.1%
 
660004620 1 < 0.1%
 

Total_Taxable_Amount
Numeric

Distinct count7096
Unique (%)41.9%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean3224116.789
Minimum0
Maximum1356338620
Zeros (%)5.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q185465.8
Median376067.25
Q31037450
95-th percentile12770625
Maximum1356338620
Range1356338620
Interquartile range951984.2

Descriptive statistics

Standard deviation20303604.73
Coef of variation6.297416022
Kurtosis1706.197108
Mean3224116.789
MAD4753252.673
Skewness33.59918963
Sum5.463910723e+10
Variance4.122363649e+14
Memory size132.5 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.00000000e+00 7.50000000e-02 1.00750000e+02 1.47615000e+02 2.14400000e+03 ... 1.02197399e+08 1.11352244e+08 1.14540404e+08 1.79293831e+08 1.35633862e+09], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 997 5.9%
 
588325 72 0.4%
 
109620 68 0.4%
 
488700 66 0.4%
 
413700 60 0.4%
 
552400 60 0.4%
 
1767640 48 0.3%
 
523100 40 0.2%
 
105840 37 0.2%
 
31053609.6 36 0.2%
 
Other values (7086) 15463 91.2%
 

Minimum 5 values

ValueCountFrequency (%) 
0 997 5.9%
 
0.15 1 < 0.1%
 
45 1 < 0.1%
 
100.1 1 < 0.1%
 
101.4 2 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1356338620 1 < 0.1%
 
919992410 1 < 0.1%
 
760000000 1 < 0.1%
 
660005280 1 < 0.1%
 
660004620 1 < 0.1%
 

Total_Taxable_Amount_Currency
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
USD
7347
JPY
4525
EUR
4518
Other values (2)
 
557
ValueCountFrequency (%) 
USD 7347 43.4%
 
JPY 4525 26.7%
 
EUR 4518 26.7%
 
AUD 553 3.3%
 
GBP 4 < 0.1%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

TRF
Numeric

Distinct count101
Unique (%)0.6%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean2.338171948
Minimum0
Maximum500
Zeros (%)70.6%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q31
95-th percentile10
Maximum500
Range500
Interquartile range1

Descriptive statistics

Standard deviation12.16933936
Coef of variation5.204638339
Kurtosis468.696877
Mean2.338171948
MAD3.674463104
Skewness17.060823
Sum39625
Variance148.0928205
Memory size132.5 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 60.5 68.5 126.5 187.5 500. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 11971 70.6%
 
1 2192 12.9%
 
2 627 3.7%
 
3 354 2.1%
 
5 297 1.8%
 
4 208 1.2%
 
10 190 1.1%
 
6 131 0.8%
 
7 111 0.7%
 
20 83 0.5%
 
Other values (91) 783 4.6%
 

Minimum 5 values

ValueCountFrequency (%) 
0 11971 70.6%
 
1 2192 12.9%
 
2 627 3.7%
 
3 354 2.1%
 
4 208 1.2%
 

Maximum 5 values

ValueCountFrequency (%) 
500 1 < 0.1%
 
429 1 < 0.1%
 
400 2 < 0.1%
 
270 1 < 0.1%
 
250 1 < 0.1%
 

Correlations

Missing values

Sample

First rows

Account_Created_DateAccount_NameAccount_OwnerAccount_TypeASPASP_(converted)ASP_CurrencyBilling_CountryBrandBureaucratic_CodeBureaucratic_Code_0_ApprovalBureaucratic_Code_0_ApprovedCurrencyDelivery_QuarterDelivery_TermsDelivery_YearIDLast_Modified_ByLast_Modified_DateMonthOpportunity_Created_DateOpportunity_IDOpportunity_NameOpportunity_OwnerOpportunity_TypePlanned_Delivery_End_DatePlanned_Delivery_Start_DatePricePricing,_Delivery_Terms_ApprovedPricing,_Delivery_Terms_Quote_ApprProduct_Category_BProduct_FamilyProduct_NameProduct_TypeQuote_Expiry_DateQuote_TypeRegionSales_Contract_NoSizeSource_StageTerritoryTotal_AmountTotal_Taxable_AmountTotal_Taxable_Amount_CurrencyTRF
02015-06-16Account_Name_619Person_Name_51Account_Type_20.520.58817EURNetherlandsNoneBureaucratic_Code_411NoneQ2Delivery_Terms_2201627761Person_Name_182016-06-132016 - 52015-12-070Opportunity_Name_12598Person_Name_18Opportunity_Type_12016-06-302016-05-01None11NoneProduct_Family_77Product_Name_99None2016-01-30Non BindingEMEANoneNoneNoneClosed LostNone5272800.05272800.0EUR10
12015-06-16Account_Name_619Person_Name_51Account_Type_20.530.59948EURNetherlandsNoneBureaucratic_Code_400NoneQ1Delivery_Terms_2201627760Person_Name_202016-01-152016 - 12015-12-071Opportunity_Name_12600Person_Name_20Opportunity_Type_12016-01-202016-01-18None00NoneProduct_Family_77Product_Name_100None2016-01-20Non BindingEMEA39NoneNoneClosed WonNone48230.048230.0EUR0
22015-04-21Account_Name_1794Person_Name_64Account_Type_50.480.48000USDUnited StatesNoneBureaucratic_Code_400NoneQ1Delivery_Terms_4201627446Person_Name_82016-09-292016 - 12015-12-082Opportunity_Name_469Person_Name_8Opportunity_Type_12016-01-252016-01-25None00NoneProduct_Family_81Product_Name_91None2016-09-30Non BindingAmericas760NoneSource_7Closed WonNW America83865.683865.6USD0
32013-07-27Account_Name_1201Person_Name_8Account_Type_50.530.53000USDUnited StatesOtherBureaucratic_Code_510USDQ1Delivery_Terms_1201816808Person_Name_82018-03-272018 - 22015-12-083Opportunity_Name_415Person_Name_8Opportunity_Type_192018-03-312018-02-010.4201Product_Category_B_16Product_Family_209Product_Name_432Product_Type_0NaTNon BindingAmericasNoneSize_4Source_11Closed LostNW America7421881.57421881.5USD14
42013-07-27Account_Name_1201Person_Name_8Account_Type_50.530.53000USDUnited StatesOtherBureaucratic_Code_510USDQ1Delivery_Terms_1201816805Person_Name_82018-03-272018 - 22015-12-084Opportunity_Name_851Person_Name_8Opportunity_Type_192018-02-282018-02-010.4201Product_Category_B_16Product_Family_209Product_Name_432Product_Type_02017-06-02Non BindingAmericasNoneSize_4Source_11Closed LostNW America13357192.513357192.5USD25
52013-07-27Account_Name_1201Person_Name_8Account_Type_50.530.53000USDUnited StatesOtherBureaucratic_Code_510USDQ1Delivery_Terms_1201816802Person_Name_82018-03-272018 - 22015-12-085Opportunity_Name_939Person_Name_8Opportunity_Type_192018-03-312018-02-010.4201Product_Category_B_16Product_Family_209Product_Name_432Product_Type_02017-06-02Non BindingAmericasNoneSize_4Source_11Closed LostNW America14838277.514838277.5USD28
62013-07-27Account_Name_1201Person_Name_8Account_Type_50.380.38000USDUnited StatesNoneBureaucratic_Code_510NoneQ1Delivery_Terms_4201716799Person_Name_82016-10-072017 - 22015-12-086Opportunity_Name_1618Person_Name_8Opportunity_Type_192017-05-012017-02-01None01NoneProduct_Family_164Product_Name_308NoneNaTNon BindingAmericasNoneNoneSource_11Closed LostNW America2659494.62659494.6USD7
72015-04-21Account_Name_1794Person_Name_64Account_Type_50.480.48000USDUnited StatesNoneBureaucratic_Code_411NoneQ1Delivery_Terms_4201627455Person_Name_82015-12-092016 - 12015-12-097Opportunity_Name_8227Person_Name_8Opportunity_Type_12016-01-252016-01-25None11NoneProduct_Family_143Product_Name_251None2016-01-07Non BindingAmericasNoneNoneSource_7Closed WonNW America50688.050688.0USD0
82015-04-20Account_Name_1888Person_Name_50Account_Type_2NaNNaNJPYJapanNoneBureaucratic_Code_500NoneQ1Delivery_Terms_4201624353Person_Name_502016-04-052016 - 22015-12-098Opportunity_Name_6151Person_Name_50Opportunity_Type_72016-02-292016-02-29None01NoneProduct_Family_6Product_Name_6NoneNaTNon BindingJapanNoneNoneNoneClosed LostNone15600.0470400.0JPY0
92015-04-20Account_Name_1888Person_Name_50Account_Type_2NaNNaNJPYJapanNoneBureaucratic_Code_500NoneQ1Delivery_Terms_4201624355Person_Name_502016-04-052016 - 22015-12-098Opportunity_Name_6151Person_Name_50Opportunity_Type_72016-02-292016-02-29None01NoneProduct_Family_4Product_Name_4NoneNaTNon BindingJapanNoneNoneNoneClosed LostNone4400.0470400.0JPY0

Last rows

Account_Created_DateAccount_NameAccount_OwnerAccount_TypeASPASP_(converted)ASP_CurrencyBilling_CountryBrandBureaucratic_CodeBureaucratic_Code_0_ApprovalBureaucratic_Code_0_ApprovedCurrencyDelivery_QuarterDelivery_TermsDelivery_YearIDLast_Modified_ByLast_Modified_DateMonthOpportunity_Created_DateOpportunity_IDOpportunity_NameOpportunity_OwnerOpportunity_TypePlanned_Delivery_End_DatePlanned_Delivery_Start_DatePricePricing,_Delivery_Terms_ApprovedPricing,_Delivery_Terms_Quote_ApprProduct_Category_BProduct_FamilyProduct_NameProduct_TypeQuote_Expiry_DateQuote_TypeRegionSales_Contract_NoSizeSource_StageTerritoryTotal_AmountTotal_Taxable_AmountTotal_Taxable_Amount_CurrencyTRF
169372013-07-27Account_Name_533Person_Name_13Account_Type_00.53000.59948EURGermanyNoneBureaucratic_Code_400NoneQ1Delivery_Terms_2201617683Person_Name_132015-12-182016 - 22015-12-0412797Opportunity_Name_4060Person_Name_13Opportunity_Type_82016-02-292016-02-01None00NoneProduct_Family_77Product_Name_96None2016-01-03Non BindingEMEANoneNoneSource_9Closed WonGermany413400.00528918.75EUR1
169382015-12-04Account_Name_586Person_Name_13Account_Type_20.47000.53161EURGermanyNoneBureaucratic_Code_500NoneQ3Delivery_Terms_2201628767Person_Name_132016-10-212016 - 82015-12-0412798Opportunity_Name_5088Person_Name_13Opportunity_Type_192016-09-302016-08-15None01NoneProduct_Family_85Product_Name_110None2016-02-05Non BindingEMEANoneNoneNoneClosed LostGermany1307775.001307775.00EUR3
169392013-07-27Account_Name_533Person_Name_13Account_Type_00.51500.58251EURGermanyNoneBureaucratic_Code_400NoneQ2Delivery_Terms_2201618324Person_Name_132016-04-012016 - 42015-12-0412799Opportunity_Name_7202Person_Name_13Opportunity_Type_12016-04-212016-04-01None11NoneProduct_Family_77Product_Name_96None2016-04-03Non BindingEMEA224NoneSource_9Closed WonNorway401700.00401700.00EUR1
169402014-06-16Account_Name_404Person_Name_13Account_Type_50.53000.53000USDGermanyNoneBureaucratic_Code_500NoneQ4Delivery_Terms_4201620827Person_Name_132016-10-102016 - 102015-12-0412800Opportunity_Name_11979Person_Name_13Opportunity_Type_192016-12-302016-10-03None01NoneProduct_Family_164Product_Name_307None2016-01-15Non BindingAmericasNoneNoneNoneClosed LostNE America10751580.0021332500.00USD20
169412014-06-16Account_Name_404Person_Name_13Account_Type_50.53000.53000USDGermanyNoneBureaucratic_Code_500NoneQ4Delivery_Terms_4201620830Person_Name_132016-10-102016 - 102015-12-0412800Opportunity_Name_11979Person_Name_13Opportunity_Type_192016-12-302016-10-03None01NoneProduct_Family_158Product_Name_286None2016-01-15Non BindingAmericasNoneNoneNoneClosed LostNE America10580920.0021332500.00USD20
169422016-01-15Account_Name_726Person_Name_13Account_Type_50.52000.58817EURAustriaNoneBureaucratic_Code_411NoneQ1Delivery_Terms_220168781Person_Name_132016-01-192016 - 32015-12-0412801Opportunity_Name_9245Person_Name_13Opportunity_Type_12016-03-252016-03-21None11NoneProduct_Family_85Product_Name_111NoneNaTNon BindingEMEA44NoneSource_7Closed WonAustria103350.00299715.00EUR0
169432016-01-15Account_Name_726Person_Name_13Account_Type_50.52000.58817EURAustriaNoneBureaucratic_Code_411NoneQ2Delivery_Terms_220168786Person_Name_132016-01-192016 - 42015-12-0412801Opportunity_Name_9245Person_Name_13Opportunity_Type_12016-04-082016-04-04None11NoneProduct_Family_85Product_Name_111NoneNaTNon BindingEMEA44NoneSource_7Closed WonAustria93015.00299715.00EUR0
169442016-01-15Account_Name_726Person_Name_13Account_Type_50.52000.58817EURAustriaNoneBureaucratic_Code_411NoneQ1Delivery_Terms_220168792Person_Name_132016-01-192016 - 32015-12-0412801Opportunity_Name_9245Person_Name_13Opportunity_Type_12016-03-312016-03-28None11NoneProduct_Family_85Product_Name_111NoneNaTNon BindingEMEA44NoneSource_7Closed WonAustria103350.00299715.00EUR0
169452015-10-20Account_Name_944Person_Name_3Account_Type_50.63750.63750USDUnited StatesNoneBureaucratic_Code_411NoneQ2Delivery_Terms_4201628561Person_Name_32016-01-222016 - 42015-12-0512802Opportunity_Name_5843Person_Name_3Opportunity_Type_12016-04-292016-04-25None11NoneProduct_Family_158Product_Name_287None2016-02-29Non BindingAmericasNoneNoneNoneClosed LostNE America2346796.880.00USD4
169462015-09-03Account_Name_1401Person_Name_3Account_Type_50.64000.64000USDUnited StatesNoneBureaucratic_Code_411NoneQ3Delivery_Terms_4201628318Person_Name_32016-09-282016 - 72015-12-0512803Opportunity_Name_9911Person_Name_3Opportunity_Type_192016-08-312016-07-01None11NoneProduct_Family_164Product_Name_307None2016-01-06Non BindingAmericasNoneNoneNoneClosed LostNE America25603200.000.00USD40